﻿CREATE TABLE [dbo].[txcx] (
    [id]                 INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyId]          INT             CONSTRAINT [DF_txcx_CompanyId] DEFAULT ((0)) NULL,
    [CompanyName]        NVARCHAR (200)  CONSTRAINT [DF_txcx_CompanyName] DEFAULT ('') NULL,
    [tx]                 DECIMAL (18, 2) CONSTRAINT [DF_txcx_tx] DEFAULT ((0)) NULL,
    [tx_PaymentTypeId]   INT             CONSTRAINT [DF_Table_1_PaymentTypeId] DEFAULT ((0)) NULL,
    [tx_PaymentTypeName] NVARCHAR (50)   CONSTRAINT [DF_Table_1_PaymentTypeName] DEFAULT ('') NULL,
    [tx_BankId]          INT             CONSTRAINT [DF_Table_1_BankId] DEFAULT ((0)) NULL,
    [tx_BankName]        NVARCHAR (50)   CONSTRAINT [DF_Table_1_BankName] DEFAULT ('') NULL,
    [cx]                 DECIMAL (18, 2) CONSTRAINT [DF_txcx_cx] DEFAULT ((0)) NULL,
    [cx_PaymentTypeId]   INT             CONSTRAINT [DF_Table_1_PaymentTypeId_1] DEFAULT ((0)) NULL,
    [cx_PaymentTypeName] NVARCHAR (50)   CONSTRAINT [DF_Table_1_PaymentTypeName_1] DEFAULT ('') NULL,
    [cx_BankId]          INT             CONSTRAINT [DF_Table_1_BankId_1] DEFAULT ((0)) NULL,
    [cx_BankName]        NVARCHAR (50)   CONSTRAINT [DF_Table_1_BankName_1] DEFAULT ('') NULL,
    [memo]               NVARCHAR (500)  CONSTRAINT [DF_txcx_memo] DEFAULT ('') NULL,
    [createdate]         DATETIME        CONSTRAINT [DF_txcx_createdate] DEFAULT (getdate()) NULL,
    [userid]             VARCHAR (20)    CONSTRAINT [DF_txcx_userid] DEFAULT ('') NULL,
    [username]           NVARCHAR (20)   CONSTRAINT [DF_txcx_username] DEFAULT ('') NULL,
    CONSTRAINT [PK_txcx] PRIMARY KEY CLUSTERED ([id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'提现金额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'txcx', @level2type = N'COLUMN', @level2name = N'tx';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'存现金额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'txcx', @level2type = N'COLUMN', @level2name = N'cx';

